Release 10.1A: OpenEdge Development:
Internationalizing Applications

SQLSCHEMA

SQLSCHEMA is a command-line utility that writes selected components of an SQL database schema to an output file using the UTF-8 code page. You might then use SQL Explorer to load the schema components into an SQL database The syntax for SQLSCHEMA (for UNIX and Windows) is:

Syntax

sqlschema -u username -a password -t table-name[,table-name ...] database-url [-g table-list ...] [-o output-filename] [-p procedure-list] [-s synonym-list] [-T trigger-list]

username, password

User authentication.

table-name[,table-name ...]

Table schemas to dump. Multiple tables can be specified, in a comma-separated list. Specify a table of % to load all tables. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.

database-url

The database to which you want to connect. This has the following form:

progress:T:host-name:service-name:database-name

table-list

Comma-separated list of one or more grant privileges to dump as grant statements. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.

output-filename

The file to which schemas are dumped. The default is screen.

procedure-list

Comma-separated list of one or more procedures for which to capture definitions. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.

synonym-list

Comma-separated list of one or more synonyms to dump as create synonym statements. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.

trigger-list

Comma-separated list of triggers for which to capture definitions. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.